merge_station

Dataset statistics

Number of variables	20
Number of observations	108035
Missing cells	422997
Missing cells (%)	19.6%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	17.3 MiB
Average record size in memory	168.0 B

Variable types

Categorical	7
Numeric	13

Alerts

`StationId` has a high cardinality: 110 distinct values	High cardinality
`Date` has a high cardinality: 2009 distinct values	High cardinality
`StationName` has a high cardinality: 110 distinct values	High cardinality
`PM2.5` is highly correlated with `PM10` and 4 other fields	High correlation
`PM10` is highly correlated with `PM2.5` and 6 other fields	High correlation
`NO` is highly correlated with `PM2.5` and 4 other fields	High correlation
`NO2` is highly correlated with `PM2.5` and 4 other fields	High correlation
`NOx` is highly correlated with `PM10` and 3 other fields	High correlation
`NH3` is highly correlated with `PM2.5` and 2 other fields	High correlation
`CO` is highly correlated with `PM10` and 1 other fields	High correlation
`Benzene` is highly correlated with `Toluene` and 1 other fields	High correlation
`Toluene` is highly correlated with `Benzene` and 1 other fields	High correlation
`Xylene` is highly correlated with `Benzene` and 1 other fields	High correlation
`AQI` is highly correlated with `PM2.5` and 6 other fields	High correlation
`PM2.5` is highly correlated with `PM10` and 1 other fields	High correlation
`PM10` is highly correlated with `PM2.5` and 3 other fields	High correlation
`NO` is highly correlated with `PM10` and 2 other fields	High correlation
`NO2` is highly correlated with `NO` and 1 other fields	High correlation
`NOx` is highly correlated with `PM10` and 2 other fields	High correlation
`Toluene` is highly correlated with `Xylene`	High correlation
`Xylene` is highly correlated with `Toluene`	High correlation
`AQI` is highly correlated with `PM2.5` and 1 other fields	High correlation
`PM2.5` is highly correlated with `PM10` and 1 other fields	High correlation
`PM10` is highly correlated with `PM2.5` and 1 other fields	High correlation
`NO` is highly correlated with `NOx`	High correlation
`NO2` is highly correlated with `NOx`	High correlation
`NOx` is highly correlated with `NO` and 1 other fields	High correlation
`Benzene` is highly correlated with `Toluene` and 1 other fields	High correlation
`Toluene` is highly correlated with `Benzene` and 1 other fields	High correlation
`Xylene` is highly correlated with `Benzene` and 1 other fields	High correlation
`AQI` is highly correlated with `PM2.5` and 1 other fields	High correlation
`State` is highly correlated with `City`	High correlation
`City` is highly correlated with `State`	High correlation
`PM2.5` is highly correlated with `PM10` and 2 other fields	High correlation
`PM10` is highly correlated with `PM2.5` and 4 other fields	High correlation
`NO` is highly correlated with `NO2` and 1 other fields	High correlation
`NO2` is highly correlated with `NO` and 1 other fields	High correlation
`NOx` is highly correlated with `PM10` and 2 other fields	High correlation
`CO` is highly correlated with `AQI`	High correlation
`SO2` is highly correlated with `City`	High correlation
`Benzene` is highly correlated with `Toluene`	High correlation
`Toluene` is highly correlated with `Benzene`	High correlation
`AQI` is highly correlated with `PM2.5` and 3 other fields	High correlation
`AQI_Bucket` is highly correlated with `PM2.5` and 4 other fields	High correlation
`City` is highly correlated with `SO2` and 2 other fields	High correlation
`State` is highly correlated with `PM10` and 2 other fields	High correlation
`PM2.5` has 21625 (20.0%) missing values	Missing
`PM10` has 42706 (39.5%) missing values	Missing
`NO` has 17106 (15.8%) missing values	Missing
`NO2` has 16547 (15.3%) missing values	Missing
`NOx` has 15500 (14.3%) missing values	Missing
`NH3` has 48105 (44.5%) missing values	Missing
`CO` has 12998 (12.0%) missing values	Missing
`SO2` has 25204 (23.3%) missing values	Missing
`O3` has 25568 (23.7%) missing values	Missing
`Benzene` has 31455 (29.1%) missing values	Missing
`Toluene` has 38702 (35.8%) missing values	Missing
`Xylene` has 85137 (78.8%) missing values	Missing
`AQI` has 21010 (19.4%) missing values	Missing
`AQI_Bucket` has 21010 (19.4%) missing values	Missing
`Benzene` is highly skewed (γ1 = 21.61702016)	Skewed
`NOx` has 4776 (4.4%) zeros	Zeros
`CO` has 7280 (6.7%) zeros	Zeros
`Benzene` has 12602 (11.7%) zeros	Zeros
`Toluene` has 10455 (9.7%) zeros	Zeros
`Xylene` has 6083 (5.6%) zeros	Zeros

Reproduction

Analysis started	2022-01-06 06:53:36.556489
Analysis finished	2022-01-06 06:54:12.270600
Duration	35.71 seconds
Software version	pandas-profiling v3.1.1
Download configuration	config.json

StationId
Categorical

HIGH CARDINALITY

Distinct	110
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

KA009	2009
DL008	2009
DL033	2009
KA003	2009
TN003	2009
Other values (105)	97990

Length

Max length	5
Median length	5
Mean length	5
Min length	5

Characters and Unicode

Total characters	540175
Distinct characters	29
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AP001
2nd row	AP001
3rd row	AP001
4th row	AP001
5th row	AP001

Common Values

Value	Count	Frequency (%)
KA009	2009	1.9%
DL008	2009	1.9%
DL033	2009	1.9%
KA003	2009	1.9%
TN003	2009	1.9%
GJ001	2009	1.9%
DL007	2009	1.9%
DL021	2009	1.9%
TN001	2009	1.9%
UP012	2009	1.9%
Other values (100)	87945	81.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
ka009	2009	1.9%
tn001	2009	1.9%
up014	2009	1.9%
tn004	2009	1.9%
dl013	2009	1.9%
mh005	2009	1.9%
up012	2009	1.9%
dl008	2009	1.9%
dl021	2009	1.9%
dl007	2009	1.9%
Other values (100)	87945	81.4%

Most occurring characters

Value	Count	Frequency (%)
0	171293	31.7%
1	48475	9.0%
L	47246	8.7%
D	47223	8.7%
3	23227	4.3%
2	21884	4.1%
T	15544	2.9%
A	14911	2.8%
4	14632	2.7%
K	13572	2.5%
Other values (19)	122168	22.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	324105	60.0%
Uppercase Letter	216070	40.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
L	47246	21.9%
D	47223	21.9%
T	15544	7.2%
A	14911	6.9%
K	13572	6.3%
G	10761	5.0%
P	10022	4.6%
H	9808	4.5%
R	8598	4.0%
B	7064	3.3%
Other values (9)	31321	14.5%

Decimal Number

Value	Count	Frequency (%)
0	171293	52.9%
1	48475	15.0%
3	23227	7.2%
2	21884	6.8%
4	14632	4.5%
5	13083	4.0%
8	8417	2.6%
6	8350	2.6%
7	8231	2.5%
9	6513	2.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	324105	60.0%
Latin	216070	40.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
L	47246	21.9%
D	47223	21.9%
T	15544	7.2%
A	14911	6.9%
K	13572	6.3%
G	10761	5.0%
P	10022	4.6%
H	9808	4.5%
R	8598	4.0%
B	7064	3.3%
Other values (9)	31321	14.5%

Common

Value	Count	Frequency (%)
0	171293	52.9%
1	48475	15.0%
3	23227	7.2%
2	21884	6.8%
4	14632	4.5%
5	13083	4.0%
8	8417	2.6%
6	8350	2.6%
7	8231	2.5%
9	6513	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	540175	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	171293	31.7%
1	48475	9.0%
L	47246	8.7%
D	47223	8.7%
3	23227	4.3%
2	21884	4.1%
T	15544	2.9%
A	14911	2.8%
4	14632	2.7%
K	13572	2.5%
Other values (19)	122168	22.6%

Date
Categorical

HIGH CARDINALITY

Distinct	2009
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

2020-03-29	108
2020-04-21	108
2020-05-17	108
2020-06-13	108
2020-04-26	108
Other values (2004)	107495

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	1080350
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2017-11-24
2nd row	2017-11-25
3rd row	2017-11-26
4th row	2017-11-27
5th row	2017-11-28

Common Values

Value	Count	Frequency (%)
2020-03-29	108	0.1%
2020-04-21	108	0.1%
2020-05-17	108	0.1%
2020-06-13	108	0.1%
2020-04-26	108	0.1%
2020-05-03	108	0.1%
2020-04-16	108	0.1%
2020-05-26	108	0.1%
2020-04-15	108	0.1%
2020-04-17	108	0.1%
Other values (1999)	106955	99.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-03-29	108	0.1%
2020-05-13	108	0.1%
2020-07-01	108	0.1%
2020-05-10	108	0.1%
2020-05-09	108	0.1%
2020-05-05	108	0.1%
2020-03-22	108	0.1%
2020-03-20	108	0.1%
2020-06-29	108	0.1%
2020-05-21	108	0.1%
Other values (1999)	106955	99.0%

Most occurring characters

Value	Count	Frequency (%)
0	260693	24.1%
-	216070	20.0%
2	191188	17.7%
1	179627	16.6%
9	50830	4.7%
8	44185	4.1%
7	32023	3.0%
6	30810	2.9%
5	28358	2.6%
3	25989	2.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	864280	80.0%
Dash Punctuation	216070	20.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	260693	30.2%
2	191188	22.1%
1	179627	20.8%
9	50830	5.9%
8	44185	5.1%
7	32023	3.7%
6	30810	3.6%
5	28358	3.3%
3	25989	3.0%
4	20577	2.4%

Dash Punctuation

Value	Count	Frequency (%)
-	216070	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	1080350	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	260693	24.1%
-	216070	20.0%
2	191188	17.7%
1	179627	16.6%
9	50830	4.7%
8	44185	4.1%
7	32023	3.0%
6	30810	2.9%
5	28358	2.6%
3	25989	2.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1080350	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	260693	24.1%
-	216070	20.0%
2	191188	17.7%
1	179627	16.6%
9	50830	4.7%
8	44185	4.1%
7	32023	3.0%
6	30810	2.9%
5	28358	2.6%
3	25989	2.4%

PM2.5
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	22395
Distinct (%)	25.9%
Missing	21625
Missing (%)	20.0%
Infinite	0
Infinite (%)	0.0%
Mean	80.27257135

Minimum	0.02
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0.02
5-th percentile	13.02
Q1	31.88
median	55.95
Q3	99.92
95-th percentile	236.5655
Maximum	1000
Range	999.98
Interquartile range (IQR)	68.04

Descriptive statistics

Standard deviation	76.52640254
Coefficient of variation (CV)	0.9533318948
Kurtosis	10.62438324
Mean	80.27257135
Median Absolute Deviation (MAD)	29.07
Skewness	2.563923541
Sum	6936352.89
Variance	5856.290285
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
11	27	< 0.1%
31.08	23	< 0.1%
28.8	22	< 0.1%
24.83	22	< 0.1%
21.38	21	< 0.1%
42.5	21	< 0.1%
34.1	21	< 0.1%
29.75	21	< 0.1%
15	20	< 0.1%
21	20	< 0.1%
Other values (22385)	86192	79.8%
(Missing)	21625	20.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.02	2	< 0.1%
0.04	1	< 0.1%
0.15	1	< 0.1%
0.16	1	< 0.1%
0.19	1	< 0.1%
0.2	1	< 0.1%
0.24	1	< 0.1%
0.25	1	< 0.1%
0.28	1	< 0.1%
0.32	1	< 0.1%

Value	Count	Frequency (%)
1000	1	< 0.1%
999.99	1	< 0.1%
995	1	< 0.1%
992.67	1	< 0.1%
949.99	1	< 0.1%
917.77	1	< 0.1%
916.67	1	< 0.1%
914.94	1	< 0.1%
914.64	1	< 0.1%
894.75	1	< 0.1%

PM10
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	29575
Distinct (%)	45.3%
Missing	42706
Missing (%)	39.5%
Infinite	0
Infinite (%)	0.0%
Mean	157.9684272

Minimum	0.01
Maximum	1000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0.01
5-th percentile	30.27
Q1	70.15
median	122.09
Q3	208.67
95-th percentile	409.386
Maximum	1000
Range	999.99
Interquartile range (IQR)	138.52

Descriptive statistics

Standard deviation	123.4186718
Coefficient of variation (CV)	0.7812869569
Kurtosis	3.383081112
Mean	157.9684272
Median Absolute Deviation (MAD)	61.83
Skewness	1.644048099
Sum	10319919.38
Variance	15232.16854
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
94	12	< 0.1%
71.88	12	< 0.1%
71.05	12	< 0.1%
108.46	11	< 0.1%
55.66	11	< 0.1%
56.6	11	< 0.1%
41.62	10	< 0.1%
31	10	< 0.1%
46.68	10	< 0.1%
65.88	10	< 0.1%
Other values (29565)	65220	60.4%
(Missing)	42706	39.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	1	< 0.1%
0.02	1	< 0.1%
0.03	1	< 0.1%
0.04	2	< 0.1%
0.06	1	< 0.1%
0.07	1	< 0.1%
0.08	1	< 0.1%
0.09	2	< 0.1%
0.1	3	< 0.1%
0.12	3	< 0.1%

Value	Count	Frequency (%)
1000	1	< 0.1%
985	2	< 0.1%
976.77	1	< 0.1%
960.98	1	< 0.1%
955.6	1	< 0.1%
952	1	< 0.1%
942	1	< 0.1%
938.5	1	< 0.1%
936.25	1	< 0.1%
933.05	1	< 0.1%

NO
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	11963
Distinct (%)	13.2%
Missing	17106
Missing (%)	15.8%
Infinite	0
Infinite (%)	0.0%
Mean	23.12342399

Minimum	0.01
Maximum	470
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0.01
5-th percentile	1.5
Q1	4.84
median	10.29
Q3	24.98
95-th percentile	93.766
Maximum	470
Range	469.99
Interquartile range (IQR)	20.14

Descriptive statistics

Standard deviation	34.49101855
Coefficient of variation (CV)	1.49160516
Kurtosis	14.05293685
Mean	23.12342399
Median Absolute Deviation (MAD)	7.02
Skewness	3.288711003
Sum	2102589.82
Variance	1189.63036
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.5	81	0.1%
2.89	79	0.1%
2.93	79	0.1%
0.73	77	0.1%
2.49	77	0.1%
3	76	0.1%
2.87	76	0.1%
2.84	75	0.1%
2.95	75	0.1%
3.99	75	0.1%
Other values (11953)	90159	83.5%
(Missing)	17106	15.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	1	< 0.1%
0.02	10	< 0.1%
0.03	4	< 0.1%
0.04	2	< 0.1%
0.06	3	< 0.1%
0.07	1	< 0.1%
0.08	3	< 0.1%
0.09	2	< 0.1%
0.1	4	< 0.1%
0.11	4	< 0.1%

Value	Count	Frequency (%)
470	1	< 0.1%
437.85	1	< 0.1%
436.8	1	< 0.1%
429.77	1	< 0.1%
403.94	1	< 0.1%
390.68	1	< 0.1%
383.14	1	< 0.1%
382.44	1	< 0.1%
374.71	1	< 0.1%
373.9	1	< 0.1%

NO2
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	12050
Distinct (%)	13.2%
Missing	16547
Missing (%)	15.3%
Infinite	0
Infinite (%)	0.0%
Mean	35.2407601

Minimum	0.01
Maximum	448.05
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0.01
5-th percentile	5.3935
Q1	15.09
median	27.21
Q3	46.93
95-th percentile	89.88
Maximum	448.05
Range	448.04
Interquartile range (IQR)	31.84

Descriptive statistics

Standard deviation	29.51082713
Coefficient of variation (CV)	0.8374060901
Kurtosis	11.06061697
Mean	35.2407601
Median Absolute Deviation (MAD)	14.41
Skewness	2.359287053
Sum	3224106.66
Variance	870.8889177
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
9	43	< 0.1%
17.58	39	< 0.1%
20	37	< 0.1%
16.07	37	< 0.1%
17.82	36	< 0.1%
9.47	36	< 0.1%
0.2	36	< 0.1%
9.14	36	< 0.1%
9.22	35	< 0.1%
13.6	35	< 0.1%
Other values (12040)	91118	84.3%
(Missing)	16547	15.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	4	< 0.1%
0.02	7	< 0.1%
0.03	9	< 0.1%
0.04	3	< 0.1%
0.05	3	< 0.1%
0.06	3	< 0.1%
0.07	7	< 0.1%
0.08	6	< 0.1%
0.09	7	< 0.1%
0.1	8	< 0.1%

Value	Count	Frequency (%)
448.05	1	< 0.1%
397.77	1	< 0.1%
397.31	1	< 0.1%
394.04	1	< 0.1%
393.08	1	< 0.1%
369.03	1	< 0.1%
363.75	1	< 0.1%
362.73	1	< 0.1%
362.5	1	< 0.1%
362.21	1	< 0.1%

NOx
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	15608
Distinct (%)	16.9%
Missing	15500
Missing (%)	14.3%
Infinite	0
Infinite (%)	0.0%
Mean	41.19505538

Minimum	0
Maximum	467.63
Zeros	4776
Zeros (%)	4.4%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	13.97
median	26.66
Q3	50.5
95-th percentile	134.153
Maximum	467.63
Range	467.63
Interquartile range (IQR)	36.53

Descriptive statistics

Standard deviation	45.1459756
Coefficient of variation (CV)	1.095907632
Kurtosis	8.454914527
Mean	41.19505538
Median Absolute Deviation (MAD)	15.84
Skewness	2.53978547
Sum	3811984.45
Variance	2038.159113
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4776	4.4%
6.24	601	0.6%
2.21	516	0.5%
9.05	37	< 0.1%
15.75	34	< 0.1%
16.56	34	< 0.1%
11.02	34	< 0.1%
22.02	34	< 0.1%
17.01	34	< 0.1%
15.09	33	< 0.1%
Other values (15598)	86402	80.0%
(Missing)	15500	14.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4776	4.4%
0.01	7	< 0.1%
0.02	3	< 0.1%
0.03	14	< 0.1%
0.04	13	< 0.1%
0.05	4	< 0.1%
0.06	2	< 0.1%
0.07	3	< 0.1%
0.08	2	< 0.1%
0.09	2	< 0.1%

Value	Count	Frequency (%)
467.63	1	< 0.1%
453.61	1	< 0.1%
442.69	1	< 0.1%
440.31	1	< 0.1%
434.9	1	< 0.1%
429.38	1	< 0.1%
402.27	1	< 0.1%
399.87	1	< 0.1%
395.86	1	< 0.1%
395.33	1	< 0.1%

NH3
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	9119
Distinct (%)	15.2%
Missing	48105
Missing (%)	44.5%
Infinite	0
Infinite (%)	0.0%
Mean	28.73287519

Minimum	0.01
Maximum	418.9
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0.01
5-th percentile	3.85
Q1	11.9
median	23.59
Q3	38.1375
95-th percentile	70.23
Maximum	418.9
Range	418.89
Interquartile range (IQR)	26.2375

Descriptive statistics

Standard deviation	24.89779732
Coefficient of variation (CV)	0.8665264843
Kurtosis	22.77179802
Mean	28.73287519
Median Absolute Deviation (MAD)	12.6
Skewness	3.218919233
Sum	1721961.21
Variance	619.9003114
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
13.42	49	< 0.1%
6.29	42	< 0.1%
14.62	39	< 0.1%
6.3	38	< 0.1%
6.28	38	< 0.1%
6.31	36	< 0.1%
6.6	34	< 0.1%
10.42	33	< 0.1%
6.25	32	< 0.1%
6.32	32	< 0.1%
Other values (9109)	59557	55.1%
(Missing)	48105	44.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	4	< 0.1%
0.02	9	< 0.1%
0.03	1	< 0.1%
0.04	2	< 0.1%
0.05	2	< 0.1%
0.06	6	< 0.1%
0.07	1	< 0.1%
0.08	2	< 0.1%
0.09	1	< 0.1%
0.1	23	< 0.1%

Value	Count	Frequency (%)
418.9	1	< 0.1%
408.58	1	< 0.1%
379.32	1	< 0.1%
371.36	1	< 0.1%
365.68	1	< 0.1%
361.75	1	< 0.1%
356.73	1	< 0.1%
352.89	1	< 0.1%
349.25	1	< 0.1%
335.91	1	< 0.1%

CO
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	2352
Distinct (%)	2.5%
Missing	12998
Missing (%)	12.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.60574934

Minimum	0
Maximum	175.81
Zeros	7280
Zeros (%)	6.7%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.53
median	0.91
Q3	1.45
95-th percentile	3.38
Maximum	175.81
Range	175.81
Interquartile range (IQR)	0.92

Descriptive statistics

Standard deviation	4.369577753
Coefficient of variation (CV)	2.721207878
Kurtosis	224.1688928
Mean	1.60574934
Median Absolute Deviation (MAD)	0.43
Skewness	12.19795088
Sum	152605.6
Variance	19.09320974
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	7280	6.7%
0.64	713	0.7%
0.66	696	0.6%
0.7	688	0.6%
0.78	679	0.6%
0.74	673	0.6%
0.68	671	0.6%
0.6	662	0.6%
0.79	659	0.6%
0.76	656	0.6%
Other values (2342)	81660	75.6%
(Missing)	12998	12.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7280	6.7%
0.01	96	0.1%
0.02	125	0.1%
0.03	54	< 0.1%
0.04	52	< 0.1%
0.05	73	0.1%
0.06	54	< 0.1%
0.07	45	< 0.1%
0.08	54	< 0.1%
0.09	59	0.1%

Value	Count	Frequency (%)
175.81	1	< 0.1%
145.32	1	< 0.1%
134.85	1	< 0.1%
132.47	1	< 0.1%
132.07	1	< 0.1%
124.01	1	< 0.1%
119.68	1	< 0.1%
119.3	1	< 0.1%
118.02	1	< 0.1%
118	1	< 0.1%

SO2
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	5801
Distinct (%)	7.0%
Missing	25204
Missing (%)	23.3%
Infinite	0
Infinite (%)	0.0%
Mean	12.2576341

Minimum	0.01
Maximum	195.65
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0.01
5-th percentile	2.07
Q1	5.04
median	8.95
Q3	14.92
95-th percentile	32.54
Maximum	195.65
Range	195.64
Interquartile range (IQR)	9.88

Descriptive statistics

Standard deviation	12.98472338
Coefficient of variation (CV)	1.059317261
Kurtosis	34.72063189
Mean	12.2576341
Median Absolute Deviation (MAD)	4.54
Skewness	4.581281421
Sum	1015312.09
Variance	168.6030412
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3.4	84	0.1%
3.38	80	0.1%
4	79	0.1%
5.86	78	0.1%
3.28	75	0.1%
3.51	75	0.1%
3.48	75	0.1%
6.42	74	0.1%
5.8	74	0.1%
6.99	74	0.1%
Other values (5791)	82063	76.0%
(Missing)	25204	23.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	2	< 0.1%
0.02	1	< 0.1%
0.03	3	< 0.1%
0.04	6	< 0.1%
0.05	3	< 0.1%
0.06	8	< 0.1%
0.07	3	< 0.1%
0.08	10	< 0.1%
0.09	4	< 0.1%
0.1	6	< 0.1%

Value	Count	Frequency (%)
195.65	1	< 0.1%
193.86	1	< 0.1%
187.02	1	< 0.1%
186.08	1	< 0.1%
182.39	1	< 0.1%
180.85	1	< 0.1%
179.18	1	< 0.1%
178.93	1	< 0.1%
178.63	1	< 0.1%
178.58	1	< 0.1%

O3
Real number (ℝ_≥0)

MISSING

Distinct	11166
Distinct (%)	13.5%
Missing	25568
Missing (%)	23.7%
Infinite	0
Infinite (%)	0.0%
Mean	38.13483551

Minimum	0.01
Maximum	963
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0.01
5-th percentile	7.02
Q1	18.895
median	30.84
Q3	47.14
95-th percentile	81
Maximum	963
Range	962.99
Interquartile range (IQR)	28.245

Descriptive statistics

Standard deviation	39.12800382
Coefficient of variation (CV)	1.026043598
Kurtosis	75.83136294
Mean	38.13483551
Median Absolute Deviation (MAD)	13.49
Skewness	6.844483445
Sum	3144865.48
Variance	1531.000683
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
16.48	35	< 0.1%
22.94	34	< 0.1%
23.6	33	< 0.1%
22.5	33	< 0.1%
34.4	32	< 0.1%
25.64	31	< 0.1%
19.12	31	< 0.1%
23.59	31	< 0.1%
21.4	30	< 0.1%
21.28	29	< 0.1%
Other values (11156)	82148	76.0%
(Missing)	25568	23.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	4	< 0.1%
0.02	9	< 0.1%
0.03	4	< 0.1%
0.04	3	< 0.1%
0.05	4	< 0.1%
0.06	3	< 0.1%
0.07	3	< 0.1%
0.08	2	< 0.1%
0.09	3	< 0.1%
0.1	11	< 0.1%

Value	Count	Frequency (%)
963	1	< 0.1%
868.2	1	< 0.1%
819.06	1	< 0.1%
777.67	1	< 0.1%
763.12	1	< 0.1%
757	1	< 0.1%
714.75	1	< 0.1%
705.32	1	< 0.1%
698.67	1	< 0.1%
694.96	1	< 0.1%

Benzene
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
SKEWED
ZEROS

Distinct	3017
Distinct (%)	3.9%
Missing	31455
Missing (%)	29.1%
Infinite	0
Infinite (%)	0.0%
Mean	3.35802925

Minimum	0
Maximum	455.03
Zeros	12602
Zeros (%)	11.7%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.16
median	1.21
Q3	3.61
95-th percentile	11.35
Maximum	455.03
Range	455.03
Interquartile range (IQR)	3.45

Descriptive statistics

Standard deviation	11.15623448
Coefficient of variation (CV)	3.322256492
Kurtosis	695.2028255
Mean	3.35802925
Median Absolute Deviation (MAD)	1.21
Skewness	21.61702016
Sum	257157.88
Variance	124.4615677
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	12602	11.7%
0.1	689	0.6%
0.01	541	0.5%
0.02	474	0.4%
0.12	439	0.4%
0.11	422	0.4%
0.03	420	0.4%
0.05	409	0.4%
0.04	403	0.4%
0.13	398	0.4%
Other values (3007)	59783	55.3%
(Missing)	31455	29.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	12602	11.7%
0.01	541	0.5%
0.02	474	0.4%
0.03	420	0.4%
0.04	403	0.4%
0.05	409	0.4%
0.06	374	0.3%
0.07	321	0.3%
0.08	337	0.3%
0.09	337	0.3%

Value	Count	Frequency (%)
455.03	1	< 0.1%
454.85	1	< 0.1%
449.38	1	< 0.1%
448.59	1	< 0.1%
445.83	1	< 0.1%
443.63	1	< 0.1%
438.01	1	< 0.1%
435.9	1	< 0.1%
435.09	1	< 0.1%
432.94	1	< 0.1%

Toluene
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	8713
Distinct (%)	12.6%
Missing	38702
Missing (%)	35.8%
Infinite	0
Infinite (%)	0.0%
Mean	15.34539426

Minimum	0
Maximum	454.85
Zeros	10455
Zeros (%)	9.7%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0.69
median	4.33
Q3	17.51
95-th percentile	64.934
Maximum	454.85
Range	454.85
Interquartile range (IQR)	16.82

Descriptive statistics

Standard deviation	29.3485873
Coefficient of variation (CV)	1.912533938
Kurtosis	33.33721267
Mean	15.34539426
Median Absolute Deviation (MAD)	4.33
Skewness	4.598334818
Sum	1063942.22
Variance	861.3395766
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	10455	9.7%
0.01	268	0.2%
0.02	199	0.2%
0.07	198	0.2%
0.03	179	0.2%
0.04	173	0.2%
0.1	173	0.2%
0.08	167	0.2%
0.06	161	0.1%
0.09	153	0.1%
Other values (8703)	57207	53.0%
(Missing)	38702	35.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10455	9.7%
0.01	268	0.2%
0.02	199	0.2%
0.03	179	0.2%
0.04	173	0.2%
0.05	147	0.1%
0.06	161	0.1%
0.07	198	0.2%
0.08	167	0.2%
0.09	153	0.1%

Value	Count	Frequency (%)
454.85	1	< 0.1%
454.12	1	< 0.1%
449.14	1	< 0.1%
448.87	1	< 0.1%
445.84	1	< 0.1%
443.63	1	< 0.1%
437.77	1	< 0.1%
435.94	1	< 0.1%
434.92	1	< 0.1%
433.02	1	< 0.1%

Xylene
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING
ZEROS

Distinct	1892
Distinct (%)	8.3%
Missing	85137
Missing (%)	78.8%
Infinite	0
Infinite (%)	0.0%
Mean	2.423446153

Minimum	0
Maximum	170.37
Zeros	6083
Zeros (%)	5.6%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0.4
Q3	2.11
95-th percentile	10.7315
Maximum	170.37
Range	170.37
Interquartile range (IQR)	2.11

Descriptive statistics

Standard deviation	6.472408501
Coefficient of variation (CV)	2.670745745
Kurtosis	119.5691605
Mean	2.423446153
Median Absolute Deviation (MAD)	0.4
Skewness	8.629738992
Sum	55492.07
Variance	41.8920718
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	6083	5.6%
0.01	500	0.5%
0.02	423	0.4%
0.1	327	0.3%
0.03	297	0.3%
0.04	241	0.2%
0.05	188	0.2%
0.12	183	0.2%
0.06	180	0.2%
0.11	168	0.2%
Other values (1882)	14308	13.2%
(Missing)	85137	78.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6083	5.6%
0.01	500	0.5%
0.02	423	0.4%
0.03	297	0.3%
0.04	241	0.2%
0.05	188	0.2%
0.06	180	0.2%
0.07	151	0.1%
0.08	148	0.1%
0.09	135	0.1%

Value	Count	Frequency (%)
170.37	1	< 0.1%
137.45	1	< 0.1%
133.6	1	< 0.1%
132.97	1	< 0.1%
129.28	1	< 0.1%
125.18	1	< 0.1%
123.29	1	< 0.1%
116.62	1	< 0.1%
109.98	1	< 0.1%
109.23	1	< 0.1%

AQI
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	930
Distinct (%)	1.1%
Missing	21010
Missing (%)	19.4%
Infinite	0
Infinite (%)	0.0%
Mean	179.7492904

Minimum	8
Maximum	2049
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	1.6 MiB

Quantile statistics

Minimum	8
5-th percentile	47
Q1	86
median	132
Q3	254
95-th percentile	415
Maximum	2049
Range	2041
Interquartile range (IQR)	168

Descriptive statistics

Standard deviation	131.3243389
Coefficient of variation (CV)	0.7305972588
Kurtosis	8.532544269
Mean	179.7492904
Median Absolute Deviation (MAD)	62
Skewness	1.930087687
Sum	15642682
Variance	17246.08198
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
104	615	0.6%
102	593	0.5%
106	587	0.5%
108	561	0.5%
100	560	0.5%
88	549	0.5%
98	547	0.5%
90	546	0.5%
92	546	0.5%
78	545	0.5%
Other values (920)	81376	75.3%
(Missing)	21010	19.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
8	1	< 0.1%
10	2	< 0.1%
13	2	< 0.1%
14	7	< 0.1%
15	5	< 0.1%
16	10	< 0.1%
17	13	< 0.1%
18	11	< 0.1%
19	36	< 0.1%
20	49	< 0.1%

Value	Count	Frequency (%)
2049	1	< 0.1%
1917	1	< 0.1%
1842	1	< 0.1%
1747	1	< 0.1%
1719	1	< 0.1%
1672	1	< 0.1%
1646	1	< 0.1%
1630	1	< 0.1%
1613	1	< 0.1%
1595	1	< 0.1%

AQI_Bucket
Categorical

HIGH CORRELATION
MISSING

Distinct	6
Distinct (%)	< 0.1%
Missing	21010
Missing (%)	19.4%
Memory size	1.6 MiB

Moderate	29417
Satisfactory	23636
Very Poor	11762
Poor	11493
Good	5510

Length

Max length	12
Median length	8
Mean length	8.32036771
Min length	4

Characters and Unicode

Total characters	724080
Distinct characters	18
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Moderate
2nd row	Moderate
3rd row	Moderate
4th row	Moderate
5th row	Moderate

Common Values

Value	Count	Frequency (%)
Moderate	29417	27.2%
Satisfactory	23636	21.9%
Very Poor	11762	10.9%
Poor	11493	10.6%
Good	5510	5.1%
Severe	5207	4.8%
(Missing)	21010	19.4%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
moderate	29417	29.8%
satisfactory	23636	23.9%
poor	23255	23.5%
very	11762	11.9%
good	5510	5.6%
severe	5207	5.3%

Most occurring characters

Value	Count	Frequency (%)
o	110583	15.3%
r	93277	12.9%
e	86217	11.9%
a	76689	10.6%
t	76689	10.6%
y	35398	4.9%
d	34927	4.8%
M	29417	4.1%
S	28843	4.0%
c	23636	3.3%
Other values (8)	128404	17.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	613531	84.7%
Uppercase Letter	98787	13.6%
Space Separator	11762	1.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	110583	18.0%
r	93277	15.2%
e	86217	14.1%
a	76689	12.5%
t	76689	12.5%
y	35398	5.8%
d	34927	5.7%
c	23636	3.9%
s	23636	3.9%
f	23636	3.9%
Other values (2)	28843	4.7%

Uppercase Letter

Value	Count	Frequency (%)
M	29417	29.8%
S	28843	29.2%
P	23255	23.5%
V	11762	11.9%
G	5510	5.6%

Space Separator

Value	Count	Frequency (%)
	11762	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	712318	98.4%
Common	11762	1.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	110583	15.5%
r	93277	13.1%
e	86217	12.1%
a	76689	10.8%
t	76689	10.8%
y	35398	5.0%
d	34927	4.9%
M	29417	4.1%
S	28843	4.0%
c	23636	3.3%
Other values (7)	116642	16.4%

Common

Value	Count	Frequency (%)
	11762	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	724080	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	110583	15.3%
r	93277	12.9%
e	86217	11.9%
a	76689	10.6%
t	76689	10.6%
y	35398	4.9%
d	34927	4.8%
M	29417	4.1%
S	28843	4.0%
c	23636	3.3%
Other values (8)	128404	17.7%

StationName
Categorical

HIGH CARDINALITY

Distinct	110
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

BWSSB Kadabesanahalli, Bengaluru - CPCB	2009
Central School, Lucknow - CPCB	2009
NSIT Dwarka, Delhi - CPCB	2009
Shadipur, Delhi - CPCB	2009
CRRI Mathura Road, Delhi - IMD	2009
Other values (105)	97990

Length

Max length	53
Median length	28
Mean length	29.00140695
Min length	17

Characters and Unicode

Total characters	3133167
Distinct characters	59
Distinct categories	8 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Secretariat, Amaravati - APPCB
2nd row	Secretariat, Amaravati - APPCB
3rd row	Secretariat, Amaravati - APPCB
4th row	Secretariat, Amaravati - APPCB
5th row	Secretariat, Amaravati - APPCB

Common Values

Value	Count	Frequency (%)
BWSSB Kadabesanahalli, Bengaluru - CPCB	2009	1.9%
Central School, Lucknow - CPCB	2009	1.9%
NSIT Dwarka, Delhi - CPCB	2009	1.9%
Shadipur, Delhi - CPCB	2009	1.9%
CRRI Mathura Road, Delhi - IMD	2009	1.9%
Lalbagh, Lucknow - CPCB	2009	1.9%
Maninagar, Ahmedabad - GPCB	2009	1.9%
Bandra, Mumbai - MPCB	2009	1.9%
Alandur Bus Depot, Chennai - CPCB	2009	1.9%
IHBAS, Dilshad Garden, Delhi - CPCB	2009	1.9%
Other values (100)	87945	81.4%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
	108035	20.1%
delhi	45360	8.5%
cpcb	28911	5.4%
dpcc	24404	4.6%
bengaluru	11996	2.2%
imd	8937	1.7%
hyderabad	8752	1.6%
tspcb	8752	1.6%
nagar	7703	1.4%
kspcb	7073	1.3%
Other values (220)	276331	51.5%

Most occurring characters

Value	Count	Frequency (%)
	428219	13.7%
a	302787	9.7%
C	180834	5.8%
r	148939	4.8%
i	148765	4.7%
e	133988	4.3%
P	126317	4.0%
l	120877	3.9%
B	112958	3.6%
,	111080	3.5%
Other values (49)	1318403	42.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	1631535	52.1%
Uppercase Letter	841067	26.8%
Space Separator	428219	13.7%
Other Punctuation	114486	3.7%
Dash Punctuation	110222	3.5%
Decimal Number	4778	0.2%
Open Punctuation	1430	< 0.1%
Close Punctuation	1430	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	302787	18.6%
r	148939	9.1%
i	148765	9.1%
e	133988	8.2%
l	120877	7.4%
h	109044	6.7%
n	108377	6.6%
u	85726	5.3%
o	67485	4.1%
t	63428	3.9%
Other values (15)	342119	21.0%

Uppercase Letter

Value	Count	Frequency (%)
C	180834	21.5%
P	126317	15.0%
B	112958	13.4%
D	93467	11.1%
S	63643	7.6%
M	36849	4.4%
I	28704	3.4%
T	26309	3.1%
A	26234	3.1%
R	20517	2.4%
Other values (13)	125235	14.9%

Decimal Number

Value	Count	Frequency (%)
2	1580	33.1%
5	1161	24.3%
3	1036	21.7%
8	882	18.5%
1	119	2.5%

Other Punctuation

Value	Count	Frequency (%)
,	111080	97.0%
.	3406	3.0%

Space Separator

Value	Count	Frequency (%)
	428219	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	110222	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1430	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1430	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2472602	78.9%
Common	660565	21.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	302787	12.2%
C	180834	7.3%
r	148939	6.0%
i	148765	6.0%
e	133988	5.4%
P	126317	5.1%
l	120877	4.9%
B	112958	4.6%
h	109044	4.4%
n	108377	4.4%
Other values (38)	979716	39.6%

Common

Value	Count	Frequency (%)
	428219	64.8%
,	111080	16.8%
-	110222	16.7%
.	3406	0.5%
2	1580	0.2%
(	1430	0.2%
)	1430	0.2%
5	1161	0.2%
3	1036	0.2%
8	882	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3133167	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	428219	13.7%
a	302787	9.7%
C	180834	5.8%
r	148939	4.8%
i	148765	4.7%
e	133988	4.3%
P	126317	4.0%
l	120877	3.9%
B	112958	3.6%
,	111080	3.5%
Other values (49)	1318403	42.1%

City
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	26
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

Delhi	45360
Bengaluru	11996
Hyderabad	8752
Chennai	6406
Lucknow	6099
Other values (21)	29422

Length

Max length	18
Median length	6
Mean length	6.815059934
Min length	5

Characters and Unicode

Total characters	736265
Distinct characters	38
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Amaravati
2nd row	Amaravati
3rd row	Amaravati
4th row	Amaravati
5th row	Amaravati

Common Values

Value	Count	Frequency (%)
Delhi	45360	42.0%
Bengaluru	11996	11.1%
Hyderabad	8752	8.1%
Chennai	6406	5.9%
Lucknow	6099	5.6%
Mumbai	5504	5.1%
Kolkata	3165	2.9%
Jaipur	3089	2.9%
Gurugram	2831	2.6%
Patna	2678	2.5%
Other values (16)	12155	11.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
delhi	45360	42.0%
bengaluru	11996	11.1%
hyderabad	8752	8.1%
chennai	6406	5.9%
lucknow	6099	5.6%
mumbai	5504	5.1%
kolkata	3165	2.9%
jaipur	3089	2.9%
gurugram	2831	2.6%
patna	2678	2.5%
Other values (16)	12155	11.3%

Most occurring characters

Value	Count	Frequency (%)
a	87703	11.9%
e	75834	10.3%
i	67022	9.1%
l	62630	8.5%
h	61706	8.4%
u	47514	6.5%
D	45360	6.2%
r	42325	5.7%
n	39265	5.3%
d	21826	3.0%
Other values (28)	185080	25.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	628230	85.3%
Uppercase Letter	108035	14.7%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	87703	14.0%
e	75834	12.1%
i	67022	10.7%
l	62630	10.0%
h	61706	9.8%
u	47514	7.6%
r	42325	6.7%
n	39265	6.3%
d	21826	3.5%
b	16651	2.7%
Other values (13)	105754	16.8%

Uppercase Letter

Value	Count	Frequency (%)
D	45360	42.0%
B	13223	12.2%
H	8752	8.1%
C	7096	6.6%
L	6099	5.6%
M	5504	5.1%
A	4294	4.0%
J	4258	3.9%
G	3333	3.1%
K	3327	3.1%
Other values (5)	6789	6.3%

Most occurring scripts

Value	Count	Frequency (%)
Latin	736265	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	87703	11.9%
e	75834	10.3%
i	67022	9.1%
l	62630	8.5%
h	61706	8.4%
u	47514	6.5%
D	45360	6.2%
r	42325	5.7%
n	39265	5.3%
d	21826	3.0%
Other values (28)	185080	25.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	736265	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	87703	11.9%
e	75834	10.3%
i	67022	9.1%
l	62630	8.5%
h	61706	8.4%
u	47514	6.5%
D	45360	6.2%
r	42325	5.7%
n	39265	5.3%
d	21826	3.0%
Other values (28)	185080	25.1%

State
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	21
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	1.6 MiB

Delhi	45360
Karnataka	11996
Telangana	8752
Tamil Nadu	6792
Uttar Pradesh	6099
Other values (16)	29036

Length

Max length	14
Median length	7
Mean length	7.558744851
Min length	5

Characters and Unicode

Total characters	816609
Distinct characters	36
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Andhra Pradesh
2nd row	Andhra Pradesh
3rd row	Andhra Pradesh
4th row	Andhra Pradesh
5th row	Andhra Pradesh

Common Values

Value	Count	Frequency (%)
Delhi	45360	42.0%
Karnataka	11996	11.1%
Telangana	8752	8.1%
Tamil Nadu	6792	6.3%
Uttar Pradesh	6099	5.6%
Maharashtra	5504	5.1%
West Bengal	3165	2.9%
Rajasthan	3089	2.9%
Haryana	2831	2.6%
Bihar	2678	2.5%
Other values (11)	11769	10.9%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
delhi	45360	35.8%
karnataka	11996	9.5%
pradesh	8801	6.9%
telangana	8752	6.9%
tamil	6792	5.4%
nadu	6792	5.4%
uttar	6099	4.8%
maharashtra	5504	4.3%
west	3165	2.5%
bengal	3165	2.5%
Other values (14)	20367	16.1%

Most occurring characters

Value	Count	Frequency (%)
a	166079	20.3%
h	78757	9.6%
e	71129	8.7%
l	65955	8.1%
i	57110	7.0%
r	50997	6.2%
D	45360	5.6%
n	43692	5.4%
t	37961	4.6%
s	23426	2.9%
Other values (26)	176143	21.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	671058	82.2%
Uppercase Letter	126793	15.5%
Space Separator	18758	2.3%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	166079	24.7%
h	78757	11.7%
e	71129	10.6%
l	65955	9.8%
i	57110	8.5%
r	50997	7.6%
n	43692	6.5%
t	37961	5.7%
s	23426	3.5%
d	21631	3.2%
Other values (9)	54321	8.1%

Uppercase Letter

Value	Count	Frequency (%)
D	45360	35.8%
T	15544	12.3%
K	13572	10.7%
P	10022	7.9%
N	6792	5.4%
M	6216	4.9%
U	6099	4.8%
B	5843	4.6%
W	3165	2.5%
R	3089	2.4%
Other values (6)	11091	8.7%

Space Separator

Value	Count	Frequency (%)
	18758	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	797851	97.7%
Common	18758	2.3%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	166079	20.8%
h	78757	9.9%
e	71129	8.9%
l	65955	8.3%
i	57110	7.2%
r	50997	6.4%
D	45360	5.7%
n	43692	5.5%
t	37961	4.8%
s	23426	2.9%
Other values (25)	157385	19.7%

Common

Value	Count	Frequency (%)
	18758	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	816609	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	166079	20.3%
h	78757	9.6%
e	71129	8.7%
l	65955	8.1%
i	57110	7.0%
r	50997	6.2%
D	45360	5.6%
n	43692	5.4%
t	37961	4.6%
s	23426	2.9%
Other values (26)	176143	21.6%

Status
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	324
Missing (%)	0.3%
Memory size	1.6 MiB

Active	106102
Inactive	1609

Length

Max length	8
Median length	6
Mean length	6.029876243
Min length	6

Characters and Unicode

Total characters	649484
Distinct characters	9
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Active
2nd row	Active
3rd row	Active
4th row	Active
5th row	Active

Common Values

Value	Count	Frequency (%)
Active	106102	98.2%
Inactive	1609	1.5%
(Missing)	324	0.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
active	106102	98.5%
inactive	1609	1.5%

Most occurring characters

Value	Count	Frequency (%)
c	107711	16.6%
t	107711	16.6%
i	107711	16.6%
v	107711	16.6%
e	107711	16.6%
A	106102	16.3%
I	1609	0.2%
n	1609	0.2%
a	1609	0.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	541773	83.4%
Uppercase Letter	107711	16.6%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
c	107711	19.9%
t	107711	19.9%
i	107711	19.9%
v	107711	19.9%
e	107711	19.9%
n	1609	0.3%
a	1609	0.3%

Uppercase Letter

Value	Count	Frequency (%)
A	106102	98.5%
I	1609	1.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	649484	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
c	107711	16.6%
t	107711	16.6%
i	107711	16.6%
v	107711	16.6%
e	107711	16.6%
A	106102	16.3%
I	1609	0.2%
n	1609	0.2%
a	1609	0.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	649484	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
c	107711	16.6%
t	107711	16.6%
i	107711	16.6%
v	107711	16.6%
e	107711	16.6%
A	106102	16.3%
I	1609	0.2%
n	1609	0.2%
a	1609	0.2%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	StationId	Date	PM2.5	PM10	NO	NO2	NOx	NH3	CO	SO2	O3	Benzene	Toluene	Xylene	AQI	AQI_Bucket	StationName	City	State	Status
0	AP001	2017-11-24	71.36	115.75	1.75	20.65	12.40	12.19	0.10	10.76	109.26	0.17	5.92	0.10	NaN	NaN	Secretariat, Amaravati - APPCB	Amaravati	Andhra Pradesh	Active
1	AP001	2017-11-25	81.40	124.50	1.44	20.50	12.08	10.72	0.12	15.24	127.09	0.20	6.50	0.06	184.0	Moderate	Secretariat, Amaravati - APPCB	Amaravati	Andhra Pradesh	Active
2	AP001	2017-11-26	78.32	129.06	1.26	26.00	14.85	10.28	0.14	26.96	117.44	0.22	7.95	0.08	197.0	Moderate	Secretariat, Amaravati - APPCB	Amaravati	Andhra Pradesh	Active
3	AP001	2017-11-27	88.76	135.32	6.60	30.85	21.77	12.91	0.11	33.59	111.81	0.29	7.63	0.12	198.0	Moderate	Secretariat, Amaravati - APPCB	Amaravati	Andhra Pradesh	Active
4	AP001	2017-11-28	64.18	104.09	2.56	28.07	17.01	11.42	0.09	19.00	138.18	0.17	5.02	0.07	188.0	Moderate	Secretariat, Amaravati - APPCB	Amaravati	Andhra Pradesh	Active
5	AP001	2017-11-29	72.47	114.84	5.23	23.20	16.59	12.25	0.16	10.55	109.74	0.21	4.71	0.08	173.0	Moderate	Secretariat, Amaravati - APPCB	Amaravati	Andhra Pradesh	Active
6	AP001	2017-11-30	69.80	114.86	4.69	20.17	14.54	10.95	0.12	14.07	118.09	0.16	3.52	0.06	165.0	Moderate	Secretariat, Amaravati - APPCB	Amaravati	Andhra Pradesh	Active
7	AP001	2017-12-01	73.96	113.56	4.58	19.29	13.97	10.95	0.10	13.90	123.80	0.17	2.85	0.04	191.0	Moderate	Secretariat, Amaravati - APPCB	Amaravati	Andhra Pradesh	Active
8	AP001	2017-12-02	89.90	140.20	7.71	26.19	19.87	13.12	0.10	19.37	128.73	0.25	2.79	0.07	191.0	Moderate	Secretariat, Amaravati - APPCB	Amaravati	Andhra Pradesh	Active
9	AP001	2017-12-03	87.14	130.52	0.97	21.31	12.12	14.36	0.15	11.41	114.80	0.23	3.82	0.04	227.0	Poor	Secretariat, Amaravati - APPCB	Amaravati	Andhra Pradesh	Active

Last rows

	StationId	Date	PM2.5	PM10	NO	NO2	NOx	NH3	CO	SO2	O3	Benzene	Toluene	Xylene	AQI	AQI_Bucket	StationName	City	State	Status
108025	WB013	2020-06-22	15.10	30.98	2.59	18.04	20.63	30.34	0.67	1.50	25.84	1.28	8.32	NaN	38.0	Good	Victoria, Kolkata - WBPCB	Kolkata	West Bengal	Active
108026	WB013	2020-06-23	19.48	42.37	3.06	20.94	23.99	32.53	0.70	1.72	28.21	1.65	5.93	NaN	44.0	Good	Victoria, Kolkata - WBPCB	Kolkata	West Bengal	Active
108027	WB013	2020-06-24	20.05	46.63	3.78	15.28	19.06	18.89	0.66	7.08	41.56	1.14	7.24	NaN	59.0	Satisfactory	Victoria, Kolkata - WBPCB	Kolkata	West Bengal	Active
108028	WB013	2020-06-25	17.03	39.64	3.23	11.42	14.65	18.98	0.57	11.39	31.76	0.79	6.85	NaN	56.0	Satisfactory	Victoria, Kolkata - WBPCB	Kolkata	West Bengal	Active
108029	WB013	2020-06-26	9.79	19.87	23.51	16.50	40.02	25.09	0.66	10.34	30.19	0.93	6.37	NaN	50.0	Good	Victoria, Kolkata - WBPCB	Kolkata	West Bengal	Active
108030	WB013	2020-06-27	8.65	16.46	NaN	NaN	NaN	NaN	0.69	4.36	30.59	1.32	7.26	NaN	50.0	Good	Victoria, Kolkata - WBPCB	Kolkata	West Bengal	Active
108031	WB013	2020-06-28	11.80	18.47	NaN	NaN	NaN	NaN	0.68	3.49	38.95	1.42	7.92	NaN	65.0	Satisfactory	Victoria, Kolkata - WBPCB	Kolkata	West Bengal	Active
108032	WB013	2020-06-29	18.60	32.26	13.65	200.87	214.20	11.40	0.78	5.12	38.17	3.52	8.64	NaN	63.0	Satisfactory	Victoria, Kolkata - WBPCB	Kolkata	West Bengal	Active
108033	WB013	2020-06-30	16.07	39.30	7.56	29.13	36.69	29.26	0.69	5.88	29.64	1.86	8.40	NaN	57.0	Satisfactory	Victoria, Kolkata - WBPCB	Kolkata	West Bengal	Active
108034	WB013	2020-07-01	10.50	36.50	7.78	22.50	30.25	27.23	0.58	2.80	13.10	1.31	7.39	NaN	59.0	Satisfactory	Victoria, Kolkata - WBPCB	Kolkata	West Bengal	Active

Overview

Variables

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length